<?
include "conninfo.php";

$search=$_POST["mysearch"];

$query="SELECT * FROM people WHERE firstname LIKE '$search%' OR surname LIKE '$search%' OR jobtitle LIKE '$search%'";

//$query="SELECT * FROM people WHERE firstname LIKE 'ian'";// only shows if firstname is ian

//$query="SELECT * FROM people WHERE firstname LIKE 'pat'
//AND jobtitle LIKE 'mum'";// only shows if firstname is pat and job is mum

$result=mysqli_query($link,$query);

$numrows=mysqli_num_rows($result);
if($numrows==0)
{
echo "nothing found";
}

//print_r($result);

while ($r=mysqli_fetch_array($result))

{echo $r["id"]." ";
echo $r["firstname"]." ";
echo $r["surname"]." ";
echo $r["jobtitle"]."<br>";}


?>